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

125 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
inflect124922(None) 
infect113413441inf_ect
inflects1336191inflects
inflict1248621inflict
deflect13399972deflect
infarct1249012infarct
infects12279712inf_ects
infest93315432inf_est
inflected1546052inflected
inflector1465352inflector
inflicts1345612inflicts
influent1147622influent
infract12610002infract
inject153210232in_ject
inlet53732402in_le_t
insect83916582in_sect
inspect1138462inspect
reflect123913712reflect
affect1448903_affect
afflict1547043afflict
analecta1045733analecta
analects1047703analects
anklet105618733ankle_t
befleck1843943befleck
coinfect15276843coinf_ect
collect113314593collect
confect143614273conf_ect
conflict1547753conflict
defect124816173def_ect
deflects14336733deflects
dialect101210263dialect
effect1437443_effect
elect74327033__elect
fleck148213593__fleck
fleet85932333__fleet
genuflect1551953genuflect
idiolect1144353idiolect
idlest74014863i_dlest
iffiest1337963iffiest
illest63615723i_llest
inanest72115363inanest
incent83320723in_cent
incept102712753in_cept
incest82918743in_cest
indent73021243in_dent
indict93115573in_dict
indirect1147523indirect
indolent91311683indolent
induct93212743in_duct
indwelt1146513indwelt
inept73622153in__ept
inert53234373in__ert
inexact1647413inexact
infancy1546173infancy
infant92315133inf_ant
infarcts1345233infarcts
infected14229403inf_ected
infecter13229153inf_ecter
infector13478853inf_ector
infer84215033inf_e_r
infers93615443inf_ers
infests10279793inf_ests
infield1135823infield
infight1437453infight
inflame1256963inflame
inflate10312313inflate
inflecting1646313inflecting
inflection1547633inflection
inflective18126573inflective
inflectors1545223inflectors
inflexed1944023inflexed
inflicted1545533inflicted
inflicter1444453inflicter
inflictor1444013inflictor
inflight1545893inflight
inflow1235293infl_ow
inflows1335523inflows
influence1446083influence
influents1245393influents
influx1643723infl_ux
infracts1346623infracts
ingest73119003in_gest
ingle64120433ingle__
ingles74420873ingle_s
injects16257453in_jects
inkiest113415043inkiest
inkjet1737453inkje_t
inkle94515833inkle__
inkles103515653inkle_s
inkless11348713inkless
inlace82513043in_lace
inlets63915573in_lets
innless7288293innless
inquest1638603inquest
insects93710843in_sects
insert64325253in_sert
inset54430863in_se_t
insolent81311553insolent
inspects1255863inspects
inswept1245733inswept
intact8314663in_tact
intellect1147443intellect
intent63122773in_tent
intreat7416303intreat
invent93316363in_vent
invert94120083in_vert
invest93014843in_vest
islet54527553i_sle_t
kinglet123114043kingle_t
neglect1047363neglect
nonelect10410283nonelect
prelect111013833prelect
reelect911515633reelect
refect114319333ref_ect
reflects13288873reflects
reflet94024233refle_t
reinfect1346483reinf_ect
ringlet82818173ringle_t
select82621173_select
singlet84120113single_t
unblest9411813unblest
uncleft1257493uncleft
unfelt92413463unf_elt
unlet54133333un_le_t
winglet113115983wingle_t

Search took 8 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.436409841.7
2DLD Change Limit1340271257.09318895.7
3Display Results1251250.0462717.4
 (SQL Overall)1786911257.57523589.6
 
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.