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

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

68 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
reflectors154550(None) 
deflectors1654771deflectors
reflector1445731reflector_
defectors15237882def_ectors
deflector1555062deflector_
effectors1755032_effectors
electors103013842_e_lectors
inflectors1545222inflectors
neglectors1363542neglectors
prelectors1447872pre_lectors
refectory1746022ref_ectory
reflections16178552reflections
reflects13288872reflect__s
refractors15156272refractors
rejectors18247612re_jectors
selectors1148962se_lectors
collectors1446593collectors
defecators1656253def_ecators
defector14277953def_ector_
deflators13348153defl_ators
deflections17187323deflections
deflects14336733deflect__s
detectors12278303de_tectors
effecters1764323_effecters
effector1644873_effector_
ejectors17328663_e_jectors
elector93313253_e_lector_
electros102811743_e_lectros
erectors103514263_e_rectors
infectors14218553inf_ectors
inflector1465353inflector_
inflictors1543953inflictors
lectors93415763___lectors
neglecters1362933neglecters
neglector1253433neglector_
prelector1348093pre_lector_
reactors103212283re__actors
realtors82811683real__tors
receptors1356923re_ceptors
rectors93520523r___ectors
redactors1247533re_dactors
reductors1246523re_ductors
reelections13167943reelections
reelects103110883reelect__s
reenactors1294383reenactors
refections151811643ref_ections
refectories1646423ref_ectories
refects124012743ref_ect__s
reflect123913713reflect___
reflected1547983reflect_ed
reflecting1638823reflecting
reflection15168993reflection
reflective1857123reflective
reflectorize2673323reflectorize
reflectorizes2773533reflectorizes
reflets103513153refle_t__s
reflexions2043303reflexions
refractor14156323refractor_
refractory18134773refractory
rejecters18257543re_jecters
rejector17237723re_jector_
relators83316123re_l_ators
reletters9138783re_letters
requestors1943183requestors
respecters1445863respecters
retractors12158583retractors
revelators13116423revelators
selector1048613se_lector_

Search took 7 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 Filter1786911406030.406440125.6
2DLD Change Limit140603685.93623686.5
3Display Results68680.0332060.6
 (SQL Overall)178691686.37528030.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.