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 “insulation” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

107 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
insulation1031166(None) 
insolation10410211insolation
insulations11310231insulations
angulation1149552angulation
annulation1068952annulation
incubation1448362incubation
inculcation1557242inculcation
inculpation1546772inculpation
induration11410612induration
inflation12311092in_flation
inhalation13107662inhalation
inhumation1567052inhumation
inoculation1358712inoculation
inosculation1445272inosculation
insolations1149182insolations
insufflation18112872insufflation
insulating1139262insulating
insulator948102insulat_or
intubation1247772intubation
isolation9311642i_solation
undulation1147102undulation
adulation10311013_adulation
ambulation1447873ambulation
angulations1268053angulations
annulations1167833annulations
circulation1549393circulation
consolation13410983consolation
consultation1447473consultation
copulation141111953copulation
cumulation1448173cumulation
desolation11311403desolation
emulation11312393_emulation
illation8311943i__llation
immolation1446103immolation
imputation1447123imputation
incitation12312223incitation
incubations1547303incubations
inculcations1666313inculcations
inculpations1675963inculpations
incurvation1646983incurvation
indagation1246153indagation
indexation1846343indexation
indication13312033indication
induction1248983indu_ction
indurations1249583indurations
infixation2047533infixation
inflations13310323in_flations
infuriation1448243infuriation
inhalations14126743inhalations
inhumations1666033inhumations
initiation10412103initiation
injunction1945093injunction
innovation1345643innovation
inoculations1457683inoculations
inosculations1554423inosculations
insertion9410593ins_ertion
insinuation11137263insinuation
insolating1149153insolating
inspection1446663inspection
inspiration1348373inspiration
installation1254913installation
instauration12114833instauration
instigation1249243instigation
instillation1245853instillation
insufflations19112623insufflations
insularism1253723insularism
insularity1354533insularity
insulate8312843insulat__e
insulated10310713insulat_ed
insulates9311843insulat_es
insulators1047263insulators
insulin738483insul__i_n
insulting1038053insul_ting
intimation12413043intimation
intonation10410263intonation
intubations1346833intubations
intuition947623intu_ition
inunction1146893in_unction
inundation11116173inundation
invitation13410023invitation
invocation1547543invocation
involution1345943involution
isolations10310693i_solations
lobulation1247233lobulation
maculation14510983maculation
mensuration1346493mensuration
modulation13147933modulation
morulation12148903morulation
nodulation11127993nodulation
nutation81513103_n_utation
osculation1249673osculation
ovulation1238983_ovulation
peculation14311993peculation
population14810023population
postulation13119133postulation
pustulation13116623pustulation
regulation11312053regulation
simulation1269583simulation
sinuation9310413sin_u_ation
solation8916153__solation
sublation11311013__sublation
sudation9310803__sudation
sulcation11710733__sulcation
sulfation1288783__sulfation
tabulation1247813tabulation
ululation938093_ululation
undulations1246053undulations

Search took 8 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 Filter1786911406030.500357382.0
2DLD Change Limit1406031076.83020586.1
3Display Results1071070.0631698.4
 (SQL Overall)1786911077.39324170.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.