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

151 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
faint8583706(None) 
fain75840561fain_
faints94818781faints
feint84732251feint
flint87333501flint
haint85436321haint
paint75443691paint
saint55147071saint
taint55542281taint
ain37579092_ain_
ains46158882_ains
airt45757782_airt
ait38093902_ai_t
ant37270782_a_nt
aunt46553652_aunt
bait66556002bai_t
bint67355032_bint
cain65643912cain_
cains75334302cains
cant66362022ca_nt
dainty105311472dainty
daunt65929082daunt
dint56759052_dint
elint55436472elint
facet106038522facet
facing125321572facing
fact97142542fa_ct
fading114821112fading
faena85014202faena
fagin9216572fagin_
fagins10513862fagins
fagot9323402fagot
fail74840242fai_l
fails85631482fails
fainer94717242fainer
fainest10417702fainest
fainted114211722fainted
fainter103611052fainter
faintly1337082faintly
fair76332522fai_r
fairs85825442fairs
fairy115318282fairy
faith115620852faith
faking145520982faking
famine114318192famine
faming124922972faming
fan67158852fa_n_
fane75343562fa_ne
fang85432542fa_ng
fanny114816042fanny
fano75831682fa_no
fans76247362fa_ns
farina94618232farina
faring105231282faring
fart76860562fa_rt
fast77052312fa_st
fat68178082fa__t
fating105328672fating
fault85428312fault
faun76226622faun_
fauna84816512fauna
fauns84516752fauns
fawn105321952fawn_
fawns115914262fawns
fawny144711712fawny
faxing175117052faxing
faying134521072faying
fazing194418642fazing
feints94813872feints
feist86230072feist
fiat76646642f_iat
fin66458032f_in_
find87532602f_ind
fine75147952f_ine
fink117532122f_ink
fino76034682f_ino
fins75849092f_ins
fist76248422f_ist
fit66365452f_i_t
fixt1410729712f_ixt
flaunt9712912flaunt
fling97023512fling
flints95617452flints
flinty126112492flinty
flirt87424752flirt
flit76539272fli_t
foin77231562foin_
foins85523382foins
foist85730972foist
font77143752f_ont
forint9325022forint
fount84727032fount
frit77044472fri_t
fritt86129412fritt
front85029222front
gain56042162gain_
gains65729512gains
gainst74914692gainst
gait56150192gai_t
gaunt65430402gaunt
giant65430592giant
glint66830182glint
haints94417582haints
hant75461582ha_nt
haunt85229132haunt
hint77455742_hint
jaunt125025272jaunt
joint125227722joint
kain85334292kain_
kainit10414482kainit
kains96125642kains
lain46146282lain_
lint416266232_lint
main65345502main_
mains75635092mains
maist75535672maist
mint66758042_mint
pain65647242pain_
pains75138282pains
paints85921832paints
painty114714752painty
pant66061252pa_nt
pint66963172_pint
plaint85323202plaint
point75338732point
print74837462print
quaint15415172quaint
quint144529902quint
rain46251732rain_
rains55140232rains
rainy85921082rainy
rant45864672ra_nt
riant55833152riant
sain45551292sain_
sains55639972sains
saints65122422saints
skint95629222skint
stint57037662stint
suint55638182suint
tain45548072tain_
tains54936322tains
taints64520532taints
taunt55532282taunt
tint46758862_tint
vain75233002vain_
vaunt85925312vaunt
wain75840192wain_
wains86930862wains
waist86132382waist
wait75553692wai_t
want76156162wa_nt

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit538001511.56334421.0
3Display Results1511510.0463282.6
 (SQL Overall)1786911511.702104988.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.