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 “fibre” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

82 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
fibre10481284(None) 
fiber104921131fiber
fibres114312121fibres
fire76245591fi_re
afire86215912afi_re
bible95119422bible
cire65836372ci_re
dire56644142di_re
fable105824752fable
fare76354462f_are
fere76342232f_ere
fiacre1137622fiacre
fiar76427332fiar_
fiars86720832fiars
fib86344272fib__
fibbed144011552fibbed
fibber134811932fibber
fibered1337642fibered
fibers114717522fibers
fibril1137162fibril
fibrin1138532fibrin
fibs96329502fib_s
fice95737112fi_ce
fiche134616742fiche
fidge104516062fidge
fie67152442fi__e
fierce11348912fierce
fiery114714792fiery
fife106027702fi_fe
fifer115519972fifer
figure10258832figure
file75446642fi_le
filer85433002filer
fille84327402fille
fimble133611752fimble
fine75147952fi_ne
finer85431562finer
fiord94313342fiord
fique1739142fique
fir66744892fi_r_
fired94829742fi_red
firer811229252fi_rer
fires85740752fi_res
firm96026452fi_rm
firn76927502fi_rn
firry115713532firry
firs76637712fi_rs
five107629742fi_ve
fiver116024942fiver
fixer154717832fixer
fixure16256542fixure
flare84823632flare
foible11410382foible
fore78351472f_ore
frere85617722frere
frore86218802frore
gibe75927782gib_e
giber85417702giber
hire75538962hi_re
ire36943172_i_re
jibe136323392jib_e
jiber145115702jiber
kibbe135211972kibbe
kibe106523452kib_e
liber74723622liber
libra74712422libra
librae84310172librae
libri74610112libri
lire47845292li_re
litre55421462litre
livre85613252livre
mire66748232mi_re
mitre75522422mitre
nitre57519682nitre
ombre94111802ombre
sabre74821502sabre
sire46150412si_re
timbre10328632timbre
tire46143352ti_re
titre54619392titre
vibe95124502vib_e
wire75839812wi_re

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.313570897.8
2DLD Change Limit53800821.65632487.9
3Display Results82820.0165125.0
 (SQL Overall)178691821.98590020.7
 
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.