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 “chairs” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

122 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
chairs11491618(None) 
chains114819701chains
chair105519631chair_
chais107530311chai_s
charrs115219191charrs
chars105936641cha_rs
choirs114911881choirs
hairs86225171_hairs
airs46447422__airs
cahiers123510672cahiers
caids85226422c_aids
cains75334302c_ains
caird85717232c_aird
cairds96411512c_airds
cairn75717512c_airn
cairns85313302c_airns
carrs75730852c_arrs
cars67364762c_a_rs
chadars1338292chadars
chadors1338752chadors
chadri1238142chadri
chads116122232cha_ds
chafers154512742chafers
chafes145017912chafes
chaffs17459612chaffs
chai95929902chai__
chain105723672chai_n
chaine115119222chaine
chaines124518732chaines
chaired134211242chaired
chaise114916412chaise
chaises124317492chaises
chakra15437532chakra
chakras16428502chakras
chalks155412142chalks
champs154915682champs
chams126028502cha_ms
changs125215372changs
chants115020392chants
chaos105622862cha_os
chapes135421872chapes
chaps125326062cha_ps
char95132152cha_r_
charas114223612charas
chard116124742cha_rd
chards125119732chards
chare105231982cha_re
chares115631802chares
charism14712202charism
chark144222712cha_rk
charks155219702charks
charm126124662cha_rm
charms135218842charms
charr104821782cha_rr
charro114212952charro
charros124312142charros
charry145012112charry
chart105038282cha_rt
charts115823092charts
chary135023132cha_ry
chasers123714922chasers
chases115128232chases
chasms135513142chasms
chats105730092cha_ts
chawers154412052chawers
chaws135022462cha_ws
chays135319742cha_ys
cheers114518912cheers
chias104625522ch_ias
chiaus113611312chiaus
chics123920942ch_ics
chins105631462ch_ins
chips125721252ch_ips
chirk144516182ch_irk
chirks155414842ch_irks
chirm125317062ch_irm
chirms135113982ch_irms
chiro105320342ch_iro
chiros114617772ch_iros
chirp124717162ch_irp
chirps135414002ch_irps
chirr105015902ch_irr
chirrs114514982chirrs
chiru105317152ch_iru
chirus114615692ch_irus
chis95933312ch_i_s
chits105424572ch_its
choir105313602choir_
churrs115111512churrs
claims105211572claims
cochairs1545902cochairs
coheirs1236752coheirs
coirs75221052c_oirs
czars164812912cza_rs
deairs74013782deairs
eclairs935962eclairs
fairs85825442_fairs
flairs95711912flairs
glairs75211332glairs
haars85620472_haars
haiks125120932_haiks
hails85231642_hails
hair76330142_hair_
hairy115316832_hairy
heirs85618562_heirs
lairs55425872_lairs
mairs76228302_mairs
mohairs1234952mohairs
pairs75325832_pairs
shaird10288702shaird
shairds11216262shairds
shairn9269062shairn
shairns10276782shairns
stairs65416332stairs
thairm1156962thairm
thairms1244452thairms
theirs94610352theirs
unchairs1345502unchairs
unhairs1036372unhairs
vairs85019132_vairs
wairs86424062_wairs
whirs115218092wh_irs

Search took 4 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 Filter178691825510.343520965.0
2DLD Change Limit825511222.65631080.9
3Display Results1221220.0304066.7
 (SQL Overall)1786911223.02958993.4
 
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.