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

107 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
inflects133619(None) 
infects12279711inf_ects
inflect1249221inflect_
inflicts1345611inflicts
analects1047702analects
deflects14336732deflects
infarcts1345232infarcts
infect113413442inf_ect_
infests10279792inf_ests
inflected1546052inflected
inflector1465352inflector
inflectors1545222inflectors
inflict1248622inflict_
influents1245392influents
infracts1346622infracts
injects16257452in_jects
inlets63915572in_le_ts
insects93710842in_sects
inspects1255862inspects
reflects13288872reflects
affects1535393_affects
afflicts1644003afflicts
analecta1045733analecta
anklets114310413ankle_ts
beflecks1943753beflecks
coinfects16344573coinf_ects
collects12279783collects
confects153110873conf_ects
conflicts1644793conflicts
defects134511523def_ects
deflect13399973deflect_
dialects11126003dialects
effects1535283_effects
elects83315003__elects
flecks154310803__flecks
fleets96915063__fleets
genuflects1651013genuflects
idiolects1243083idiolects
incents92414533in_cents
incepts11238283in_cepts
incests92711383in_cests
indents83114663in_dents
indicts103210723in_dicts
inducts10259573in_ducts
inerts64517023in__erts
infants102210773inf_ants
infarct1249013infarct_
infected14229403inf_ected
infecter13229153inf_ecter
infecters14257583inf_ecters
infector13478853inf_ector
infectors14218553inf_ectors
infers93615443inf_e_rs
infest93315433inf_est_
infields1244013infields
infights1545573infights
inflames1377323inflames
inflate10312313infl_ate
inflates11512193inflates
inflecting1646313inflecting
inflection1547633inflection
inflections1646993inflections
inflective18126573inflective
inflexed1944023inflexed
inflicted1545533inflicted
inflicter1444453inflicter
inflicters1543453inflicters
inflictor1444013inflictor
inflictors1543953inflictors
inflows1335523infl_ows
influences1545653influences
influent1147623influent_
influxes1844343influxes
infract12610003infract_
ingests83210983in_gests
ingles74420873ingle__s
inject153210233in_ject_
inkles103515653inkle__s
inkless11348713inkle_ss
inlaces92512903in_laces
inlet53732403in_le_t_
innless7288293innle_ss
inquests1744943inquests
insect83916583in_sect_
inserts74013993in_serts
insets64016133in_se_ts
insolents9137523insolents
inspect1138463inspect_
intellects1245213intellects
intents72115703in_tents
intreats8311543intreats
invents102812053in_vents
inverts103211953in_verts
invests10319683in_vests
islets64513083i_sle_ts
kinglets13318583kingle_ts
neglects1144383neglects
prelects1299723prelects
reelects103110883reelects
refects124012743ref_ects
reflect123913713reflect_
reflets103513153refle_ts
reinfects1444723reinf_ects
ringlets92910233ringle_ts
selects91912143_selects
singlets93611473single_ts
winglets12299593wingle_ts

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621076.76621602.4
3Display Results1071070.0462326.1
 (SQL Overall)1786911077.23524698.1
 
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.