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

113 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
tripoli93713(None) 
tripolis1038711tripolis
trifold1136242trifold
triol55521362tri_ol_
triols66117802tri_ols
triple84215922trip_le
triploid1147362triploid
triply114211022trip_ly
tripod9399852tripo_d
tripodic1345332tripodic
tripods10359052tripods
tripody13395982tripody
tripos84014922tripo_s
aioli5318313_ai_oli
ariosi64313033ari_osi
bricole112810493bricole
brocoli1146353brocoli
cipolin1148783_cipolin
crapola1136913crapola
cripple13378583cripple
dipole91112853_dipole
frijol1634123frijol_
frijole1734583frijole
frivol1235113frivol_
frivols1334743frivols
gripple12416613gripple
oriole6814293ori_ole
propolis12311403propolis
repoll8410793_repoll
ripely112511153_ripely
ripoff1436433_ripoff
ripost83615003_ripost
ripple103413913_ripple
ripply13348003_ripply
tadpole1036143tadpole
thiol87616043thi_ol_
thiolic1247323thi_olic
thiols95112763thi_ols
tipi69924443t_ip__i
tipoff1436383t_ipoff
tipple103411913t_ipple
topoi76018353t_opo_i
trefoil1066063trefoil
tremolo946513tremolo
triable92515393triable
trial54926353tri_al_
trials64319883tri_als
triazole1744153triazole
tribal8611133tribal_
tribals9610753tribals
trickle133613443trickle
trickly16369893trickly
tricolor10115833tricolor
tricorn937963tricorn
tricot8317753trico_t
tricots9311563tricots
trifle94012883tri_fle
trifolium1443243trifolium
triforia1145653triforia
triform1237853triform
trigly103810943tri_gly
trigo65716053trigo__
trigon74513103trigo_n
trigons84312093trigons
trigos74214173trigo_s
trill55122933tri__ll
trills64319853tri_lls
trilogy1136013trilogy
trimly114410893tri_mly
trinal6516963trinal_
trindle83311363trindle
trio45233343tri_o__
triode75311893tri_ode
triolet73219523tri_olet
trios55528093tri_o_s
triose64715383tri_ose
trioxid1546613tri_oxid
trip66830393trip___
tripack1565673tripack
tripart9311433tripart
tripe75425383trip__e
tripes85324873trip_es
tripled104113833tripled
triples94616873triples
triplet94319213triplet
triplex16447803triplex
tripling112712553trip_ling
triplite1039103trip_lite
triploids1245893triploids
triploidy1543683triploidy
tripodal1145143tripodal
tripodies1246573tripodies
triposes1039973triposes
tripped123911693tripped
tripper113711923tripper
trippet113714113trippet
trippy13457803trip_py
trips74923363trip__s
triptan947543triptan
trisome9310223trisome
trisomic1245943trisomic
trisomy1235943trisomy
tritely1039003tritely
tritoma948053tritoma
triton63914893trito_n
tritone73613883tritone
tritons73814883tritons
troll54416533tr__oll
tropeolin1145743tropeolin
troponin1047943troponin
tufoli933973t_ufoli
utriculi1043223utriculi
zeppoli2042133zeppoli

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271138.11016526.1
3Display Results1131130.0462456.5
 (SQL Overall)1786911138.56220870.2
 
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.