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 “fixure” 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
fixure1625654(None) 
figure10258831figure
fixture1734961fixture
fixures17596061fixures
failure1035752failure
fiacre1137622fiacre
fibre104812842fi_bre
figured12196472figured
figurer11215852figurer
figures11239102figures
fique1739142fiqu_e
fire76245592fi__re
fissure1036782fissure
fixate1638732fixate
fixer154717832fixer_
fixers165112982fixers
fixtures1835282fixtures
flexure1743412flexure
future939562future
inure54119052_inure
ligure7279472ligure
mixture1635412mixture
abjure1536733abjure
adjure1435833adjure
affixture2251813affixture
afire86215913afi__re
allure63012943allure
armure8710133armure
assure6610773assure
azure14911483_azure
bistre83815023bistre
cire65836373ci__re
colure8314153colure
cure66149123__cure
demure9311533demure
dilute72911803dilute
dire56644143di__re
disuse74012833disuse
dure56341813__dure
endure74014143endure
ensure63416003ensure
enure53520223_enure
epicure1136823epicure
exude134010293_exude
exurb1457703_exurb
facture12108923facture
failures1135163failures
fare76354463f__are
fauve114712073f_auve
feature1039853feature
femur1038683femur_
femurs1136713femurs
fere76342233f__ere
ferule93413203ferule
fiacres1237253fiacres
fiance11310743fiance
fiar76427333fi_ar_
fiars86720833fi_ars
fibber134811933fibber
fiber104921133fiber_
fibered1337643fibered
fibers114717523fibers
fibres114312123fi_bres
fibula11258053fibula
fibulae12237013fibulae
fice95737113fi__ce
fiche134616743fi_che
fickle153912973fickle
ficus105015493ficu_s
ficuses12159203ficuses
fiddle113613383fiddle
fidge104516053fi_dge
fie67152443fi___e
fierce11348913fierce
fiery114714793fi_ery
fife106027703fi__fe
fifer115519973fifer_
fifers125414923fifers
figural1145233figural
figurate1237183figurate
figurers12254863figurers
figurine1245603figurine
filar84819293filar_
filaree10611193filaree
filature1145423filature
file75446643fi__le
filer85433003filer_
filers94623723filers
fille84327403fi_lle
filler94623623filler
filmer114112403filmer
filose96112503filose
filter94517633filter
filum105015433filu_m
fimble133611743fimble
finale94116763finale
finder104020233finder
fine75147953fi__ne
finer85431563finer_
finery124512883finery
finger104920323finger
finite9316823finite
fiord94313343fi_ord
fipple13329063fipple
fiques1837973fiques
fir66744893fi__r_
fired94829743fi__red
firer811229253fi__rer
firers94922683firers
fires85740753fi__res
firm96026453fi__rm
firmer114712443firmer
firn76927503fi__rn
firry115713533fi_rry
firs76637713fi__rs
fisher124917143fisher
fissured1235183fissured
fissures1136573fissures
fitter94120033fitter
five107629743fi__ve
fiver116024943fiver_
fivers124420923fivers
fix136236103fix___
fixable19218193fixable
fixated1835533fixated
fixates1737383fixates
fixed165416953fix_ed
fixes154723593fix_es
fixing174813783fixing
fixit154819303fix_it
fixity19427803fixity
fixt1410729713fix__t
fizzer17369383fizzer
fizzle17369713fizzle
flare84823633f_lare
fleury12417353fleury
flexures1843423flexures
flour84916453flour_
floured11289873floured
flours94414053flours
floury12449573floury
flue75329853f_lu_e
fluke125016893f_luke
flume106021173f_lume
flute86823753f_lute
fore78351473f__ore
four76226863f_our_
fours85521493f_ours
foxfire2042563foxfire
foxier163910033foxier
frere85617723f_rere
frore86218803f_rore
fugue94313373fugu_e
fume96727633f__ume
fur66637323f__ur_
furl77030883f__url
furore9410013furore
furs76735043f__urs
fury107727973f__ury
furze176815813f__urze
fuse76429993f__use
futures10310263futures
fuze166422373f__uze
gigue71210673gigu_e
guipure1043533guipure
hire75538963hi__re
immure1036023immure
impure1038373impure
injure133410863injure
insure63416603insure
inured73114813_inured
inures63318953_inures
inurn53712863_inurn
ire36943173_i__re
ixora1236913_ixora
ixtle12168013_ixtle
leisure736693leisure
ligule74010833ligule
ligures8269883ligures
lire47845293li__re
litre55421463li_tre
livre85613253li_vre
lure45142463__lure
luxury1642543luxury
manure8313653manure
mature8313463mature
minute83414293minute
mire66748223mi__re
misuse83213643misuse
mitre75522423mi_tre
mixer145017643mixer_
mixers154513563mixers
mixtures1735753mixtures
mixup1636773mixu_p
mixups1743263mixups
mure65941333__mure
nature6311263nature
nitre57519683ni_tre
nixe115722023nix__e
nixie125114943nix_ie
ordure756803ordure
parure8312523parure
picture1158613picture
pilule8411123pilule
pique16410173piqu_e
pixie145415523pix_ie
pure65543333__pure
rasure6311423rasure
refigure1254693refigure
secure8513533secure
seisure738193seisure
seizure1634683seizure
sieur5911893sieur_
sieurs659043sieurs
sire46150413si__re
sixte126216583six_te
soilure736233soilure
stoure64814943stoure
sure45447413__sure
suture6313203suture
tenure6311613tenure
texture1497083texture
timbre10328623timbre
tire46143353ti__re
titre54619393ti_tre
unpure82911533unpure
unsure62815413unsure
velure939773velure
wire75839813wi__re

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 Limit1127162296.53317253.3
3Display Results2292290.0603816.7
 (SQL Overall)1786912296.73326539.6
 
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.