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

200 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
unfair93623(None) 
funfair1342031funfair
unhair937331unhair
affair1234352affair
fair76332522__fair
funfairs1442132funfairs
unai44824782un_ai_
unais53420772un_ais
unbar71913612unba_r
unchair1236162unchair
unfairer11184282unfairer
unfairly1443562unfairly
unfaith1345782unfaith
unfit84518562unf_it
unfix15429032unf_ix
unhairs1036372unhairs
unlaid7311752unlaid
unnail6410582unnail
unpaid939472unpaid
unsaid7411832unsaid
afar76720783_afa_r
affaire1344463affaire
affairs1334163affairs
air38058393___air
anear55420323anea_r
antiair7310313antiair
antiar6317173antiar
chair105519633_chair
deair65817193_deair
eclair836813eclair
enface112510353enface
entail61114343entail
fail74840243__fail
fain75840563__fain
fairs85825443__fairs
fairy115318283__fairy
fakir125111493__fakir
faqir17548643__faqir
far67762603__fa_r
fiar76427333__fiar
fir66744893__f_ir
flair86114123_flair
flir76422203__flir
glair65313553_glair
gnar56021383gn_a_r
gnarr64810693gn_arr
gunfire1134743gunf_ire
hair76330143__hair
impair1036003impair
infall939403infall
infamy1435653infamy
infant92315133infant
infare9313083infare
infer84215033inf_er
infirm1137043inf_irm
infix15337773inf_ix
inlaid7310143inlaid
invar839513inva_r
kaffir16345303kaffir
kafir12488903kaf_ir
kefir12457913kef_ir
knar85818723kn_a_r
knaur9508253kn_aur
lair45934153__lair
lunar57017313lun_a_r
maftir1136493maftir
mair66133783__mair
midair937993midair
mohair1135203mohair
nadir61012973_nadir
naif76839023_n_aif
nail45838653_n_ail
naira5314743_n_aira
nairu5413813_n_airu
near45236503_nea_r
noir46722433_n_oir
pair66031513__pair
repair84011463repair
safari91110223safari
snail57020203sn_ail
sofar86115493sofa_r
stair54719943_stair
suffari1345503suffari
sunfast1038503sunfast
uakari1046863uakari
ulnar56013983ulna_r
unafraid1242663unafraid
unaired82916013un_aired
unakin10310963unakin
unapt710421593un_apt
unarm7314453un_arm
unary8315993un_ary
unau43924153un_a_u
unaus53216573un_aus
unbale83616403unbale
unban72114333unba_n
unbans81912623unbans
unbars82113033unbars
unbear889163unbear
unbid83214643un_bid
unbraid1037183unbraid
uncage93014873uncage
uncake122813523uncake
uncap9312283unca_p
uncaps1039813uncaps
uncase83817433uncase
uncast84215713uncast
unchain1238943unchain
unchairs1345503unchairs
unchic1338643unchic
unci65019463un_ci_
uncia75015163un_cia
unciae83215313unciae
uncial83715223uncial
unclip1046993unclip
uncoil8811853uncoil
under64624213un_der
undid72415363un_did
undoer73113043undoer
uneager839753uneager
unease63816643unease
uneasier836963uneasier
uneasy9278853uneasy
unfaded123111733unfaded
unfading1347693unfading
unfairest1243563unfairest
unfaiths1443213unfaiths
unfaked153211173unfaked
unfancy1545203unfancy
unfazed20299053unfazed
unfed94614223unf_ed
unfelt92413463unfelt
unfired112212453unf_ired
unfits93910293unfits
unfixt16398423unfixt
unfold10179703unfold
unfond10149113unfond
unfree9413203unfree
unfurl937953unfurl
ungird887973un_gird
ungirt71112713un_girt
unguis738453unguis
unhaired12238763unhaired
unhairer11174993unhairer
unhand10410383unhand
unhang1038443unhang
unhat81119263unha_t
unhats91110623unhats
unhip10178823un_hip
uniface1236953uniface
unific1137463unific
unifier102211863unifier
unit45140073un__it
uniter64619143uniter
unjam1448723unja_m
unjams1555703unjams
unknit1068593unknit
unlace82215173unlace
unlade72714153unlade
unlash938793unlash
unlay84613703unla_y
unlays93810493unlays
unlit55025463un_lit
unmade92911063unmade
unmake122811213unmake
unmaker13279513unmaker
unman72715423unma_n
unmans82211993unmans
unmask1265903unmask
unmix14388973un_mix
unmoor836313unmoor
unnails738223unnails
unpack1457833unpack
unpaired11208943unpaired
unpin72613243un_pin
unplait948603unplait
unrepair1042373unrepair
unrig61711413un_rig
unrip72012863un_rip
unsafe9310693unsafe
unsawn9317463unsawn
unsay83212843unsa_y
unsays9399543unsays
unship1148033unship
untack1239763untack
untame82513603untame
untie54425493un_tie
until53517743un_til
untrim8310683untrim
unveil957343unveil
unwarier1136883unwarier
unwary1239823unwary
unwit84417523un_wit
unzip16207623un_zip
upstair943983upstair
upstir835383upstir
urari54619963u_rari
vair75624143__vair
wair75830053__wair
zaffir21395513zaffir

Search took 6 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 Filter1786911127160.436409841.7
2DLD Change Limit1127162004.84323274.0
3Display Results2002000.0633174.6
 (SQL Overall)1786912005.34233450.2
 
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.