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

159 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
arranges93941(None) 
arrange838681arrange_
arranged1036931arranged
arranger936881arranger
arrangers1045821arrangers
arraigns944352arraigns
arrases71214542arra_ses
barrages11711092barra_ges
deranges1039972deranges
granges93516522_granges
oranges84215332_oranges
ranges73826932__ranges
rearranges1145112rearranges
stranges94516762stranges
aberrances1475433aberrances
abrades10312083abra_des
abridges1245313abridges
acreages1138383acreages
adages8412953a_da_ges
advances1445613advances
aerates74627503aera_tes
agrafes1137523agra_fes
agraffes1553043agraffes
airings83913843airing_s
alkanes113812933alkan_es
allonges937313allonges
ambages1269623amba_ges
anankes1138763a_nankes
andantes9310853andantes
anlages82414113anla_ges
apanages1137013a_panages
appanages1443993appanages
arables91814983a_rables
arames84622573a_ra_mes
arcades101113193arca_des
arcane81216743arcan_e_
arcanums1274163arcanums
archangel1544313archangel
archangels1643283archangels
arenes64928393a_ren_es
armings103811503arming_s
arracks1387733arra_cks
arraign845063arraig_n
arraigned11103033arraigned
arraigner1092973arraigner
arraigners11142683arraigners
arranging1156303arranging
arrant6623253arran__t
arrantly1156103arrantly
arras55626143arra___s
arrased8149873arra_sed
arrayals1154483arrayals
arrayed11117163arra_yed
arrayer10136703arra_yer
arrayers11125853arrayers
arrays95311683arra__ys
arrearages1143043arrearages
arrises71617583arr_ises
arrives101311513arr_ives
arrogances1344243arrogances
arsines73518843arsin_es
astringes1038343astringes
atlantes838553atlantes
avenges1157543a_venges
averages1249183avera_ges
baronages1247153baronages
barrage10710853barra_ge_
barraged1297703barra_ged
barrancas1345093barrancas
barrancos1344203barrancos
borages103917163bora_ges
boranes93720403boran_es
carnages11312213carna_ges
carriages1238333carriages
cartages11313313carta_ges
changes134517583_changes
cranes84330753_cran_es
cringes103215503_cringes
derange939813derange_
deranged1137693deranged
deranger1037353deranger
derangers1136703derangers
disarranges1363853disarranges
durances1158683durances
earringed1144453earringed
earrings9299633earring_s
enrages83114853enra_ges
errancies1147963errancies
errands847603erran_ds
errants7410643erran_ts
estranges10359983estranges
farragoes1344633farragoes
flanges113413273_flanges
forages114217283fora_ges
fringes113514103_fringes
furanes103214863furan_es
garages9314113gara_ges
garbages1238183garba_ges
grange83716203_grange_
granger93514213_granger
grangers103011973_grangers
grunges93310403_grunges
harangues1344643harangues
larynges1244503larynges
manges94628953__manges
marranos1038423marran_os
marriages1247383marriages
melanges1138613melanges
midranges1344653midranges
mirages102213533mira_ges
narrates8312763narra_tes
orange74016323_orange_
orangey11388833_orangey
orangs74116033_orang_s
ourangs8318503ourang_s
outranges102510013outranges
parangs104314383parang_s
parlances1348963parlances
parridges1384563parridges
prances113618783_prances
pranged114512553_pranged
prangs94816233_prang_s
prearranges1453043prearranges
rages64539443__ra_ges
rances84625443__rances
ranees64623963__ranees
range64728423__range_
ranged84824323__ranged
ranger73925533__ranger
rangers83621043__rangers
ratanies8312923ratanies
ravages1139403rava_ges
rearrange1045043rearrange_
rearranged1244103rearranged
sprangs104610053sprang_s
springes114014033springes
strange85416343strange_
stranger94715103stranger
strangers104112173strangers
strangest103210843strangest
strangles103011563strangles
syringes122810213syringes
tarriances1244213tarriances
terranes82514433terran_es
trances93919643_trances
triages82613793tria_ges
triangles1035753triangles
variances14117373variances
warpages1437053warpa_ges
warranted1345013warranted
warrantee1245283warrantee
warrantees1343443warrantees
warranter1245203warranter
warranters1344543warranters
warranties1344683warranties
warrants1168503warran_ts
wrangles1237473_wrangles
wrangs104611913_wrang_s
yardages1336203yarda_ges

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.423422437.4
2DLD Change Limit1461621596.93621073.0
3Display Results1591590.0801987.5
 (SQL Overall)1786911597.43924020.8
 
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.