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

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

90 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
triller7421589(None) 
driller84311881driller
friller104111741friller
griller84513351griller
thriller1165551thriller
tiller64222541t_iller
trifler103912151trifler
trilled84116311trilled
trillers83613491trillers
troller73913171troller
biller84923482_biller
brailler1036882brailler
bridler103811072bridler
chiller124112182chiller
cruller968752cruller
drilled94711672drilled
drillers9429722drillers
droller84110282droller
eviller1056672eviller
filler94623622_filler
frilled113911602frilled
frillers11349872frillers
frillier1136512frillier
giller74519732_giller
grille74315742grille_
grilled94012832grilled
grillers93810812grillers
grillery12355502grillery
grilles83715022grilles
hiller94421632_hiller
iller54821292__iller
killer104917952_killer
kruller1145152kruller
miller84625412_miller
prilled104712992prilled
rifler94014262_rifler
rille55728732_rille_
rilled74525652_rilled
rilles64725502_rilles
rillet64828852_rillet
roller63919792_roller
shriller1136822shriller
siller64026062_siller
spiller92914332spiller
stiller73414292stiller
stroller848172stroller
swiller103211662swiller
tailer63823732tai_ler
taille63116922taille_
tailles72516472tailles
tailleur843302tailleur
taller63721962t_aller
teller63519812t_eller
thrilled1235492thrilled
thrillers1244472thrillers
tiler56131022t_i_ler
tilled74722952t_illed
tillers73418742t_illers
tilter63417692t_ilter
toiler63918282toi_ler
toller63819442t_oller
trailer73015392trailer
trawler104011902trawler
tricker134615522tricker
trier54328532tri__er
trifle94012882trifle_
trifled113711962trifled
triflers113110212triflers
trifles103814822trifles
trigger9329162trigger
trill55122932trill__
trills64319852trill_s
trimer85717152tri_mer
trimmer113610832trimmer
triolet73219522triolet
triple84215922triple_
tripled104113832tripled
triples94616872triples
triplet94319212triplet
triplex16447802triplex
tripper113711922tripper
triter65120592tri_ter
trolled84312262trolled
trollers83211212trollers
trolley10328752trolley
tuille63012642tuille_
tuilles72411922tuilles
twilled11398032twilled
twirler10285202twirler
willer94021062_willer

Search took 5 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 Filter1786911076710.1401276364.3
2DLD Change Limit107671904.11026197.3
3Display Results90900.0332727.3
 (SQL Overall)178691904.28341721.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.