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

96 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
impellers134510(None) 
impeller1236081impeller_
impellors1352641impellors
compellers1645192compellers
cupellers1374862cupellers
dispellers13115442dispellers
expellers18104742expellers
impalers12226972imp_alers
impeders13346592impe_ders
impelled1336072impelle_d
impellent1346442impellent
impellents1444362impellents
impellor1242742impellor_
repellers11278872repellers
smellers10329762sm_ellers
spellers102812752_spellers
appealers1345063appealers
appellees1344033appellees
appellors1343543appellors
bevellers14276113bevellers
compeller1546293compeller_
cupelers1266733cupe_lers
cupeller1256103cupeller_
dispeller12146973dispeller_
duellers9268223_duellers
dwellers12356083_dwellers
empalers12226743emp_alers
expellees18133803expellees
expeller17105783expeller_
fellers104117543__fellers
fuellers11277983_fuellers
gospellers1363013gospellers
gruellers1034183gruellers
hellers103619833__hellers
imbalmers1543103imbalmers
impacters15305483impacters
impairers1343713impairers
impaler11298393imp_aler_
impales113311763imp_ale_s
imparters13276573imparters
impeachers1942693impeachers
impeder12438533impe_der_
impedes124310093impe_de_s
impelling1436913impelling
impels10389523impe_l__s
impingers14284063impingers
impleaders1543193impleaders
implies11312123imp_lie_s
implorers13124413implorers
implores12127043imp_lores
importers13247763importers
imposers12278463imp_osers
imposters13347343imposters
impowers15296823imp_owers
improvers1645043improvers
impugners14573473impugners
impulses1235223impulse_s
imputers1235823imp_uters
indwellers1472353indwellers
jewellers1943533jewellers
labellers11206553labellers
levellers12286043levellers
libellers11236033libellers
melders103213913_m_elders
melters93918313_m_elters
mewlers12288983_m_ewlers
micelles1288833micelle_s
millers93621343_m_illers
modellers1245393modellers
mullers93217303_m_ullers
pedlers103013273__pedlers
peelers93615593__peelers
pellets94014783__pellets
pelters93720313__pelters
pollers93420023__pollers
propellers1455203propellers
pullers93618483__pullers
quellers17237533_quellers
ravellers12257163ravellers
repealers11278843repealers
repeller103010393repeller_
resellers9299903resellers
revellers12319503revellers
sellers73721313__sellers
shellers112812573_shellers
simperers1335933simpe_rers
smeller94212783sm_eller_
smelters103310513sm_elters
spallers102910733_spallers
speller95415143_speller_
spelters103912243_spelters
spillers103311703_spillers
tellers73717593__tellers
umbellets1343343umbellets
yellers103912953__yellers
yodellers1343973yodellers

Search took 10 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 Filter1786911486410.1561145455.1
2DLD Change Limit148641968.96616578.3
3Display Results96960.0961000.0
 (SQL Overall)178691969.21819385.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.