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 “unpolite” 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.

76 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
unpolite104917(None) 
impolite1249292impolite
polite83625072__polite
unpoliced1445162unpoliced
unpolitic1345802unpolitic
aerolite8315053aerolite
anolyte10159003an_olyte
aplite8316393_ap_lite
apposite12410013apposite
coprolite1348623coprolite
cryolite1347503cryolite
haplite12310703hap_lite
hoplite12311073hop_lite
inosite7314063in_osite
insolate8311893insolate
involute1145473involute
iolite63221983__iolite
kryolite1544493kryolite
neolith1068783_neolith
niobite937953_niobite
nonpolice1345663nonpolice
norite63221133_n_orite
oolite63319603__oolite
opposite1247133opposite
pelite84323003__pelite
pisolite10310373pisolite
podite93315353__podite
police102918563__police
politer92417073__politer
polity113015863__polity
rhyolite1445513rhyolite
saponite10410533saponite
saprolite1147833saprolite
scapolite1346243scapolite
sepiolite1146803sepiolite
spoliate1039243_spoliate
unakite1138743un_akite
unalike11311533un_alike
unbolt83013893unbol_t_
unbolted1179323unbol_ted
unbolts9247803unbol_ts
undocile1145953undocile
undulate9310403undulate
ungulate939803ungulate
unholier1137283unholier
unholily1444133unholily
unifoliate1353033unifoliate
unionise847863unionise
unionize1747063unionize
unite54828383un___ite
unlike102614063un__like
unlit55025463un__lit_
unlive92712333un__live
unmolten1044933unmol_ten
unpile81914323unp__ile
unpiling1139753unpiling
unplait948603unplait_
unplaited1236883unplaited
unplaits1044813unplaits
unpoetic1245313unpoetic
unpointed1237153unpointed
unpoised1139183unpo_ised
unpolished1643433unpolished
unpolled1168943unpolled
unpolluted1342133unpolluted
unposted1159433unpo_sted
unpotted11108393unpo_tted
unsolid8138373unsoli_d
unsplit956563unsplit_
unspoilt1044883unspoilt_
unvoice12126153unvo_ice
unwhite1336813un_white
uplit76020803u_p_lit_
uralite71714103u_ralite
urolith1048783u_rolith
zeolite1638903_zeolite

Search took 7 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 Filter1786911461620.423422437.4
2DLD Change Limit146162766.37622923.8
3Display Results76760.0302533.3
 (SQL Overall)178691766.82926166.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.