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

182 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
soffit123787(None) 
soffits1335091soffits
boffin14359052boffin
coffin14339812coffin
comfit133112422comfit
confit113316402confit
haffit1538532haffit
sobeit8315342sobeit
soft76942822so_f_t
softie93312472softie
suffix1935232suffix
affix1836003_affix
afrit8323173_afrit
befit105222663_befit
biffin14369103biffin
boff124727333boff__
boffed15369483boffed
boffing16339983boffing
boffins15329073boffins
boffo136010373boff_o
boffos14568193boffos
boffs134915503boff_s
bowfin14338353bowfin
buffet143113783buffet
buffi136112203buffi_
coedit9316233coedit
coff126930783coff__
coffee144113743coffee
coffer144112863coffer
coffing163811253coffing
coffins153110193coffins
coffle14359043coffle
coffret15310073coffret
coffs134916303coff_s
coft97939683co_f_t
comfits14328743comfits
commit124016703commit
confits122811423confits
doff116225783doff__
doffed14428503doffed
doffer133911353doffer
doffing15357793doffing
doffs125614333doff_s
doit56347853do__it
fit66365453___fit
flit76539273__flit
forfeit1339203forfeit
forrit91916623forrit
frit77044473__frit
godwit1137513godwit
goffer13409513goffer
haffet15311703haffet
haffits1636193haffits
hobbit132810533hobbit
kaffir16345303kaffir
loft76539143lo_f_t
maffia14327203maffia
misfit112813833misfit
muffin14298873muffin
nonfat9512183nonfat
obit66837083_o_bit
off96331633_off__
offal1136243_offal
offcut1444703_offcut
offed12359163_offed
offer114311383_offer
office1435693_office
offing13368643_offing
offish15137273_offish
offs107117013_off_s
offset1238373_offset
oft67744063_o_f_t
omit65337373_o_mit
orbit73622063_orbit
outfit93014943outfit
pfft12311883_pff_t
posit75833333po_sit
profit113016273profit
puffin141149003puffin
raffia12287703raffia
refit84230063_refit
roofie93411173roofie
safest95016603safest
schuit1139563schuit
scoff134413343scoff__
scoffed16266183scoffed
scoffer15317023scoffer
scoffing17275943scoffing
scoffs14347503scoff_s
semifit1249973semifit
sennit63117923sennit
shaft115725253shaf_t
shift114225133shif_t
shit76745933s__hit
shrift12413543shrift
sift710740663s_if_t
sit35877753s___it
skit85437523s__kit
skylit1338273skylit
slit46250103s__lit
smit65138413s__mit
snit46342473s__nit
sobful1136333sobful
socket123923523socket
sodic84917483so_dic
sofa75625603so_f_a
sofar86115493so_far
sofars94712783sofars
sofas85320713so_fas
softa86415183so_fta
softas94410403softas
soften9429493soften
softer94015313softer
softest10310603softest
softies103414613softies
softish13127813softish
softly12457763softly
softs85019233so_fts
softy115414483so_fty
soil46138823so__il
soldi65717193soldi_
solei55624333solei_
soli46637003so_li_
solicit9315743solicit
solid65025073so_lid
soloist7915893soloist
somite84519373so_mite
sonant6621953sonant
sonic75225283so_nic
sonnet65923503sonnet
sonsie6614853sonsie
soot45761053so__ot
sophist12311553sophist
sopite84917713so_pite
sorbet83924073sorbet
sorbic10310383sorbic
sordid83411153sordid
sorest65027993sorest
sori46039833so_ri_
sort46264813so__rt
sortie63621983sortie
sot310384293so___t
souffle13306793souffle
sought106315053sought
soviet9720153soviet
sozin14514523so_zin
spait75631603s_pait
spirit83519923spirit
spit65545083s__pit
split75729013s_plit
spotlit947283spotlit
sprit76736403s_prit
stiffie13245773stiffie
strait64025893strait
subfix1835073subfix
submit10312673submit
suffer124314513suffer
suffice15197573suffice
suit45649873s__uit
sulfid1039063sulfid
sulfite10310473sulfite
summit10311543summit
sunlit61516103sunlit
surfeit10310343surfeit
swift116818053swif_t
taffia12286903taffia
tiffin12327933tiffin
toff105929903toff__
toffee123311013toffee
toffies133210213toffies
toffs116016723toff_s
toffy145310283toff_y
toft77441653to_f_t
toit46353063to__it
tomtit8413853tomtit
tuffet122612083tuffet
unfit84518563_unfit
vomit102622573vo_mit
waffie15338563waffie
worrit92313313worrit
zaffir21395513zaffir
zoftig1932973zoftig

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127161825.78319490.9
3Display Results1821820.0603033.3
 (SQL Overall)1786911825.98329866.5
 
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.