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

68 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
armourers115406(None) 
armorers10288971armo_rers
armourer1054881armourer_
armoires1057622armoire_s
armorer9259912armo_rer_
armoured1165222armoure_d
armouries1146242armouries
armours9389852armou__rs
armures9510272arm_ure_s
arousers84810982ar_ousers
abhorrers1442983abhorrers
abjurers1733943a_bjurers
accouters1344863accouters
adjurers1634373a_djurers
admirers1134713adm_irers
adorers84411733a_do_rers
allurers8286773a_llurers
almoners1068133almo_ners
amours83512663a_mou__rs
amusers94610193a_m_users
arbores94016033arbo_re_s
arboured1156253arboure_d
arbours93910043arbou__rs
ardours8368883ardou__rs
arguers8489033ar_gu_ers
armatures1166983armature_s
armers85520273arm___ers
armigers1135703arm_igers
armoire938133armoire__
armored102610473armo_re_d
armories10313653armo_ries
armorless1143483armorless
armors85017813armo___rs
armour84411853armou__r_
armouring1244983armouring
armoury12376233armou__ry
armure8710133arm_ure__
arouser74514423ar_ouser_
arouses74921293ar_ouse_s
assurers866313a_ssurers
augurers9114813a_ugurers
carousers1156743car_ousers
colourers1136473colourers
devourers1344093devourers
favourers1543123favourers
groupers11358643gr_oupers
grousers93810733gr_ousers
grouters95910083gr_outers
harborers1446913harbo_rers
honourers1245573honourers
labourers1144713labourers
mourners1036913__mourners
mousers95216443__mousers
murmurers1342673murm_urers
pourers93513673__pourers
procurers1345033procurers
roarers73812743_r_oarers
rousers75220143_r_ousers
routers74822873_r_outers
savourers1243833savourers
scourers10348533_scourers
tabourers1144673tabourers
tambourers1442743tambourers
tourers73512743__tourers
troupers10359443tr_oupers
trousers83910633tr_ousers
vapourers1443373vapourers
warmongers1643633warmongers

Search took 7 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 Filter1786911486410.423422437.4
2DLD Change Limit148641686.48622917.2
3Display Results68680.0302266.7
 (SQL Overall)178691686.93925751.7
 
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.