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

96 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
armrests105538(None) 
armrest9310161armrest_
arrests73312681ar_rests
armets84918352arm_e_ts
armless9369942armles_s
armlets94610062armle_ts
arrest63722632ar_rest_
acquests1944643acquests
actress948533actres_s
address956103addres_s
addrest958633addrest_
afforests1543733afforests
afreets1037013a_freets
aggress935593aggres_s
aigrets82810533aigre_ts
aimless93610813aimles_s
airest63825263a_irest_
almagests1242613almagests
aments85219803a_m_ents
amnesty1244823a_mnesty
amorists10411333amorists
amreeta945163a_mreeta
amreetas1044273a_mreetas
anapests1046613anapests
ancress978613ancres_s
anureses837973anureses
anuresis846963anuresis
aorists74215833a_orists
arabesks1442743arabesks
arbalests1144123arbalests
arbelests1143653arbelests
arborists1147453arborists
argents84014853ar_gents
aridest8316143aridest_
armaments1347473armaments
armers85520273arm_e_rs
armet76739463arm_e_t_
armies85123693armie__s
armlet84118193armle_t_
armorers10288973armore_rs
armorless1143483armorles_s
armpits1157133arm_pits
armures9510273armure__s
arpents93613083ar_pents
arrases71214543ar_rases
arrears738843ar_rears
arrested939173ar_rested
arrestee849443ar_restee
arrestees946233ar_restees
arrester839253ar_rester
arresters948203ar_resters
arrestor847653ar_restor
arrestors958033ar_restors
arrises71617583ar_rises
artiest73121993artiest_
artists74215593ar_tists
artless73712513artles_s
attests7278813a_ttests
aurists74615783a_urists
backrests1744983backrests
barghests1543313barghests
barguests1243483barguests
barmiest125212783barmiest_
barrets94917103bar_re_ts
crests85218703__crests
darndests1183143darndests
earnests837853ear_nests
forests104114953_forests
garments1139973garm_ents
garrets84413623gar_re_ts
harmless1337403harmles_s
harvests14246173har_vests
imprests1246313imprests
marmosets1344833marmosets
prests84021263__prests
pretests10310013pretests
priests93810863pr_iests
protests10310493protests
ramets83517393ram_e_ts
ramjets1635163ramje_ts
rarest65725483_rarest_
rearrests945313rear_rests
reests64618893_r_eests
renests74014213_renests
rerents73319423_rerents
rests54935873___rests
retests73813853_retests
revests104413733_revests
sarments10311963sarm_ents
tempests1234443tempests
unrests7229463_unrests
varments1339063varm_ents
wardress12256163wardres_s
warmest123113033warm_est_
warmness1337063warmnes_s
wrests95313083__wrests

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.436409841.7
2DLD Change Limit146162967.04620744.0
3Display Results96960.0462087.0
 (SQL Overall)178691967.52823736.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.