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

229 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
filmic1334845(None) 
filmi105914001filmi_
filmis114610281filmis
felsic1147052felsic
fillip11268952fillip
film94828172film__
filmed124610362filmed
filmer114112402filmer
filmier1237502filmier
filmily1535732filmily
filming133210352filming
films105617962film_s
filmy136114042film_y
fistic11812572fistic
flic96223732f_l_ic
folic105319322fol_ic
formic13310452formic
holmic1338772holmic
mimic111414322mi_mic
acmic11312333_acmic
agamic113110543agamic
anemic102713693anemic
anomic102516303anomic
atomic104115603atomic
aulic74420243aul_ic
billie85019173billie
bionic103614573bionic
biopic123710673biopic
biotic103816603biotic
bromic122412693bromic
bulimic1345143bulimic
cadmic1338973cadmic
calcic9311873calcic
chemic153012093chemic
chymic18317883chymic
cilia73016763cil_ia
cilice103213353cil_ice
citric102812303citric
civic123412543ci_vic
clinic104312793clinic
clitic103315053clitic
colic95726173col_ic
comic114721813_comic
cosmic12410343cosmic
cultic105111903cultic
deltic9312503deltic
demic105119193_demic
dermic114511913dermic
diamin9312513diamin
dilemmic1542873dilemmic
diploic1247763diploic
disomic1238763disomic
domic104317243_domic
emic86422753__emic
exilic1597783exil_ic
fabric1337833fabric
falsie93513853falsie
fanfic1436313fanfic
felid94717173fel_id
fermi103914163fermi_
fermis114313503fermis
ferric1139993ferric
fibril1137163fibril
fibrin1138533fibrin
ficin103516723fi_cin
fil65447143fil___
fila74729133fil__a
filar84819293fil_ar
filaria1039653filaria
filch134813323fil_ch
file75446643fil__e
filed95331903fil_ed
filemot1246703filemot
filer85433003fil_er
filers94623723filers
files85441273fil_es
filet85540163fil_et
filets94718953filets
filial93013253filial
filing103823763filing
fill75540193fil__l
fille84327403fil_le
filled104922263filled
filler94623623filler
filles94224523filles
fillet95027083fillet
fillies103420253fillies
filling113520803filling
fillips12298133fillips
fillo84319783fil_lo
fillos94415073fillos
fills84632373fil_ls
filly114424903fil_ly
filmdom1562943filmdom
filmers124211293filmers
filmiest1338553filmiest
filmlike1734443filmlike
filmset1257513filmset
filo76034283fil__o
filos86125383fil_os
filose96112503filose
fils75838693fil__s
filter94517633filter
filth115015823fil_th
filths12389783filths
filthy15356423filthy
filum105015433fil_um
finis86824263fi_nis
firkin1337823firkin
firm96026453firm__
firman112211343firman
firmed125411883firmed
firmer114712443firmer
firming132811223firming
firmly1436663firmly
firms105217423firm_s
fisc96819753fi__sc
fixit154819303fi_xit
fizgig2032973fizgig
flail85316183f_lail
flair86114123f_lair
flick145017213f_l_ick
flics105418363f_l_ics
flimsy14345563flimsy
flip96324263f_l_ip
flir76422203f_l_ir
flit76539273f_l_it
floc95922123f_l_oc
fluid94013963f_luid
folia83618933fol_ia
folio83820883fol_io
folkie13369613folkie
follis93113903follis
formica1436443formica
frolic1149203frolic
fulfil1246423fulfil
fulgid1137043fulgid
fulmar1137253fulmar
fulmine1257963fulmine
fulminic1543493fulminic
fundic12389083fundic
fungic12387813fungic
fustic11910633fustic
gallic9411633gallic
gamic103916193_gamic
gillie74816943gillie
gimmick1843273gimmick
gimmie11298183gimmie
gnomic11248593gnomic
haemic133210083haemic
hemic125718623_hemic
hili75626633hil_i_
humic124113243_humic
iambic12468273_iambic
ictic9311803_ictic
ileac75814173_ileac
ilia46026823_il_ia
iliac75013493_iliac
imid76122293_i_mid
immix1635033_immix
iodic84816753_iodic
ionic74622663_ionic
jimmie17376473jimmie
kalmia1238893kalmia
karmic1438113karmic
kilim11711883kil_im
kilims1277903kilims
killick1295313killick
killie104114893killie
kiltie103210963kiltie
laic65931563__laic
lilac7311073lil_ac
limbic12528743limbic
limit73126343li_mit
limnic10418843limnic
lithic1139493lithic
malic94525653mal_ic
melic94722333mel_ic
miasmic1335743miasmic
mic77647643___mic
milia72719573mil_ia
mimics1289363mi_mics
miotic103715743miotic
neumic1036853neumic
niobic1037243niobic
nitric82512063nitric
ohmic1237833_ohmic
oilman839483oilman
oilmen848313oilmen
oleic7313333_oleic
osmic939913_osmic
pelvic13307553pelvic
pianic103714123pianic
picnic123410263picnic
picric12309923picric
pilei74021783pilei_
pili66130353pil_i_
pilis75825203pil_is
pionic103515953pionic
polemic13311253polemic
psalmic1345333psalmic
pyemic1537893pyemic
relic74623363rel_ic
salic73424713sal_ic
salmi7815863salmi_
salmis8514273salmis
seismic1145753seismic
sialic8313633sialic
silica8311243sil_ica
silicic1147603silicic
silkie103313403silkie
silvics1235563silvics
simlin8311733simlin
telic76019823tel_ic
telomic1147603telomic
thymic16307413thymic
timid84815723ti_mid
titmice1144663titmice
toluic837693toluic
trismic1137473trismic
uremic103410513uremic
viatic11311453viatic
villi86517853villi_
vinic10314973vi_nic
viremic1436153viremic
vitric112510113vitric
willie94116453willie
wimmin1336153wimmin
zincic1935903zincic

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.1401276364.3
2DLD Change Limit1127162295.40620850.2
3Display Results2292290.0763013.2
 (SQL Overall)1786912295.62231784.2
 
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.