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

114 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
fibulae1223701(None) 
fibula11258051fibula_
fibular12267971fibular
fibulas12228561fibulas
fabular12288692fabular
fabulate1339202fabulate
faculae123210352faculae
feculae12339202feculae
ferulae10309602ferulae
fistulae1144532fistulae
ligulae8308752ligulae
nebulae955492nebulae
aciculae12267703aciculae
alulae6312743_alulae
ambulate1239733ambulate
bible95119423bib_l_e
blae66134643__b_lae
bulge86419873__bulge
bullae83416163__bullae
canulae9311183canulae
ciboule1145093ciboul_e
copulae112810613copulae
cupulae11347853cupulae
dibble114013843dibbl_e
divulge1243103divulge
divulse1134913divulse
fable105824753fab_l_e
fabulated1546323fabulated
fabulates1447733fabulates
facula112912233facula_
facular122810443facular
faunae95210373f_aunae
fecula113310053fecula_
ferula93011173ferula_
ferulas103110753ferulas
ferule93413203ferul_e
fibre104812843fib__re
fibrillae1463473fibrillae
fickle153912973fickl_e
fiddle113613383fiddl_e
figuline1256033figuline
figural1145243figural
figurate1237193figurate
figure10258833figu_re
fila74729133fi__la_
filar84819293fi__lar
file75446643fi__l_e
fille84327403fi__lle
fimble133611753fimbl_e
fimbriae1543773fimbriae
finale94116763final_e
fipple13329063fippl_e
fique1739143fiqu__e
fistula1045503fistula_
fistular1144253fistular
fistulas1155403fistulas
fistulate1246453fistulate
fixure16256543fixu_re
fizzle17369713fizzl_e
foible11410383foib_l_e
formulae1345983formulae
fribble14287783fribbl_e
furculae1345063furculae
inulase739413_inulase
kibble143910953kibbl_e
kibla1139833kib_la_
kiblah1535583kib_lah
kiblas1239323kib_las
libelee92510983libelee
liblab1035083lib_lab
librae84310173lib_rae
ligula7359673ligula_
ligular8348533ligular
ligulas8329173ligulas
ligulate92510253ligulate
ligule74010833ligul_e
lingulae9357033lingulae
lobular936663lobular
lobulate1078833lobulate
lobule82910063lobul_e
lunulae735613lunulae
maculae113412863maculae
morulae958963morulae
nebula857333nebula_
nebular956483nebular
nebulas957583nebulas
nebule848753nebul_e
nibble103713283nibbl_e
pabular11259473pabular
papulae11249353papulae
pilular938203pilular
pilule8411123pilul_e
pinnulae1044183pinnulae
radulae837963radulae
sibilate1049533sibilate
simular938673simular
simulate10311133simulate
spiculae12218603spiculae
spinulae10276963spinulae
spirulae10216573spirulae
subulate10312743subulate
tabular9279763tabular
tabulate10310893tabulate
tibiae838483tib_iae
titular737523titular
torulae758553torulae
tribulate1148083tribulate
tubular9267473tubular
tubulate1038273tubulate
tubule839853tubul_e
ungulae837313ungulae
uvulae945323_uvulae
villae95615383vi_llae
zonulae1645963zonulae

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271145.78023188.1
3Display Results1141140.0462478.3
 (SQL Overall)1786911145.98229871.4
 
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.