Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “interplay” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

53 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
interplay144716(None) 
interlay11310041inter_lay
interplays1545521interplays
interclan1148602interclan
interlap1048592inter_lap
interlays1248082inter_lays
interplant12119572interplant
interplayed1745242interplayed
interplead1345602interplead
interpled1239602interpled
underplay1545192underplay
counterplay18105603counterplay
enterally12410013enterally
inertly1038543in_ertl_y
innerly1037133inner_l_y
integrally1445893integrally
intently1149823intentl_y
intercalary1654733intercalary
intercity14410003intercity
interclass1246993interclass
interclub1344393interclub
interflow1544633interflow
interlace11311903inter_lace
interlaid1049353inter_laid
interlaps1148233inter_laps
interlard1048453inter_lard
interlayer1346923inter_layer
interleaf1248043interleaf
interloan948773interloan
intermale11712293intermale
intermat101114613inter_mat
internal8414073inter_nal
internally13410093internally
internals9712723internals
interparty1546853interparty
interphase1545993interphase
interplants13116753interplants
interplaying1845513interplaying
interpleads1444523interpleads
interpolate1369333interpolate
interpose11410463interpose
interpret11413363interpret
interval11710443inter_val
intervale12911583intervale
intervals12810133intervals
interwar1148263inter_war
intraday1244803int_raday
overplay16257553_overplay
underclay1545063underclay
underlay12147653under_lay
underpay14136213underp_ay
underplays1644653underplays
winterly14306743winter_l_y

Search took 9 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911486410.1561145455.1
2DLD Change Limit148641538.25018017.1
3Display Results53530.0301766.7
 (SQL Overall)178691538.43621182.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.