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

80 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
fibres11431212(None) 
fibers114717521fibers
fibre104812841fibre_
fires85740751fi_res
bibles104617642bibles
cires74932912ci_res
fables114921672fables
fares85852872f_ares
feres86038182f_eres
fiacres1237252fiacres
fiars86720832fiar_s
fibbed144011552fibbed
fibber134811932fibber
fibbers144510602fibbers
fiber104921132fib_er
fibered1337642fibered
fibril1137162fibril
fibrils1236842fibrils
fibrin1138532fibrin
fibrins1238632fibrins
fibroses1345972fibroses
fibrous1237592fibrous
fibs96329502fib__s
fices106031162fi_ces
fiches145219532fiches
ficoes114613462ficoes
fidges114114392fidges
fifers125414922fifers
fifes114822392fi_fes
figures11239112figures
filers94623722filers
files85441272fi_les
filles94224522filles
fimbles143510662fimbles
fines86644262fi_nes
fiords10498622fiords
fiques1837972fiques
fire76245592fi_re_
fired94829742fi_red
firer811229252fi_rer
firers94922682fi_rers
firms105217422fi_rms
firns86018542fi_rns
firs76637712fi_r_s
fishes125221342fishes
fivers124420922fivers
fives116027362fi_ves
fixers165112982fixers
fixes154723592fi_xes
fixures17596062fixures
fizzes174512552fizzes
flares94521702flares
foibles1238852foibles
fores85847102f_ores
freres94716172freres
gibers95114662gibers
gibes84422522gib_es
hires86134342hi_res
ires45639282_i_res
jibers155912882jibers
jibes145520322jib_es
kibbes143811192kibbes
kibes115521112kib_es
libers84721442libers
libras83711702libras
litres65220392litres
livres94311862livres
mires75640882mi_res
mitres83922072mitres
nitres65519332nitres
ombres103911142ombres
ribes75530172rib_es
sabres85520862sabres
sires55945372si_res
timbres11249352timbres
tires55437492ti_res
titres64718932titres
vibes104719952vib_es
vires84529682vi_res
wires86034912wi_res

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 Filter178691825511.080165454.6
2DLD Change Limit82551804.15619863.1
3Display Results80800.0302666.7
 (SQL Overall)178691805.26633933.0
 
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.