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

115 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
arranger93688(None) 
arrange838681arrange_
arranged1036931arranged
arrangers1045821arrangers
arranges939411arranges
arraigner1092972arraigner
arrayer10136702arra_yer
deranger1037352deranger
granger93514212_granger
ranger73925522__ranger
stranger94715102stranger
warranter1245202warranter
abrader1038643abra_der
abridger1243803abridger
advancer1443493advancer
anger66225873___anger
arcane81216743arcan_e_
archangel1544313archangel
armiger1036253a_rmiger
arraign845063arraig_n
arraigned11103033arraigned
arraigners11142683arraigners
arraigns944353arraigns
arranging1156303arranging
arrant6623253arran__t
arrantly1156103arrantly
arrased8149863arra_sed
arrases71214543arra_ses
arrayed11117153arra_yed
arrayers11125853arra_yers
arrester839253arrester
arriver10117793arr_iver
avenger1135493a_venger
banger94423633__banger
barracker1744653barracker
barrage10710843barra_ge_
barraged1297683barra_ged
barrages11711083barra_ges
barrater10310143barra_ter
barrener1038333barren_er
bragger113810043_bragger
brander103915823_brander
branner94212373_branner
bringer104213353_bringer
changer134215543_changer
clanger104113493_clanger
cranker133612793_cranker
cringer103514243_cringer
danger83722823__danger
derange939813derange_
deranged1137693deranged
derangers1136703derangers
deranges1039973deranges
deringer1038143deringer
derringer1144593derringer
dragger10309173_dragger
earringed1144453earringed
endanger1045853endanger
estranger10447843estranger
flanger113412623_flanger
forager114412563fora_ger
franker143510183_franker
ganger83721463__ganger
grander93315873_grander
grange83716203_grange_
grangers103011973_grangers
granges93516523_granges
granter84117133_granter
groaner82510133groan_er
grunger9389783_grunger
hanger104023253__hanger
haranguer1342863haranguer
harbinger1544123harbinger
manger94325003__manger
narrater838723narra_ter
orange74016323_orange_
orangery12305543_orangery
oranges84215333_oranges
orangey11388833_orangey
orangier947713_orangier
porringer1244053porringer
prancer113613383_prancer
pranged114512553_pranged
range64728413__range_
ranged84824313__ranged
rangers83621043__rangers
ranges73826923__ranges
rangier83714353__rangier
ranker105021903__ranker
ranter63826823__ranter
ravager1136563rava_ger
rearrange1045033rearrange_
rearranged1244103rearranged
rearranges1145113rearranges
ringer74526063__ringer
sanger74524563__sanger
springer113311753springer
strander97112063strander
strange85416343strange_
strangers104112163strangers
stranges94516763stranges
strangler10369473strangler
stringer93812943stringer
stronger9349693stronger
twanger11327433_twanger
urbaner9177133urban_er
warmonger1543853warmonger
warranted1345013warranted
warrantee1245273warrantee
warranters1344533warranters
warrantor1243213warrantor
warrener1136913warren_er
wrangler1245473_wrangler
wringer113612453_wringer
wronger11288823_wronger

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621156.83021400.0
3Display Results1151150.0462500.0
 (SQL Overall)1786911157.29624491.6
 
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.