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

81 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
unchairs134550(None) 
unchains1338301unchains
unchair1236161unchair_
unhairs1036371un_hairs
chairs114916182__chairs
cochairs1545902cochairs
enchains1348522enchains
unchain1238942unchai_n
unchaired1536202unchaired
unchary1537262uncha_ry
unhair937332un_hair_
anchors123912953anch_ors
armchairs1642573armchairs
bedchairs1742603bedchairs
chains114819703__chains
chair105519633__chair_
chais107530313__chai_s
charrs115219193__charrs
chars105936643__cha_rs
choirs114911883__choirs
cochair1446313cochair_
eclairs935963_eclairs
enchain1248863enchai_n
enchants1347833enchants
enchasers1445093enchasers
enchases13310273enchases
eschars1237183escha_rs
eucharis1347443eucharis
funfairs1442133fun_fairs
hairs86225173___hairs
inchers123912523inch_ers
longhairs1342733longhairs
lunchers13349563lunch_ers
mohairs1234953_mohairs
munchers15318773munch_ers
munchies1539253munch_ies
munchkins2042913munchkins
nuchals12216933nucha_ls
nunchakus1851723nunchakus
punchers152610073punch_ers
pushchairs2051183pushchairs
unais53420773un__ai_s
unbars82113033un_ba_rs
unbears998043unbea_rs
unbraids1144963unbraids
uncages103213773unc_ages
uncakes133012743unc_akes
uncaps1039813unc_a_ps
uncases93516553unc_ases
unchained1537273unchained
unchairing1644603unchairing
unchancy1844703unchancy
uncharge1446313uncharge
uncharges1546213uncharges
uncharred1536103uncharred
unchaste1346923unchaste
unchic1338643unch_i_c
unchokes17227273unchokes
uncials92510523uncia_ls
unclamps1443693unclamps
unclasps1244573unclasps
unclips1136433unc_lips
uncoils979533unc_oils
uncovers1336573uncovers
uncrates10314563uncrates
underhairs1445453underhairs
unfair936233un_fair_
unhaired12238763un_haired
unhairer11174993un_hairer
unhairers12183273un_hairers
unhands1137773un_hands
unhangs1136203un_hangs
unhats91110623un_ha_ts
unnails738223un_nails
unplaits1044813unplaits
unrepairs1142043unrepairs
unsharp1235543unsha_rp
unships1237203unsh_ips
upstairs1043643upstairs
urchins1238863urch_ins
wingchairs1951473wingchairs

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 Limit146162816.76621602.4
3Display Results81810.0302700.0
 (SQL Overall)178691817.21924752.9
 
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.