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

93 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
sufficer1622582(None) 
suffice15197571suffice_
sufficed17205661sufficed
sufficers17204531sufficers
suffices16208181suffices
buffier1568402buffi_er
huffier1637492huffi_er
officer1534212_officer
puffier1547972puffi_er
snuffier14276942snuffi_er
stuffier14336622stuffi_er
suffer124314512suff__er
sufferer1436062sufferer
suffixed22214342suffixed
suffixes21196352suffixes
surfacer1345662surfacer
surfier102613542surfi_er
affixer2033913_affixer
buffer144512683buff__er
buffeter1683593buffeter
chuffier1934543chuffi_er
daffier1457833daffi_er
duffer134711663duff__er
effacer15255413_effacer
fluffier13264333fluffi_er
gruffier1544703gruffi_er
gulfier1137793gulfi_er
iffier1236763_iffi_er
juicer1536283ju__icer
mafficker2342253mafficker
miffier1537023miffi_er
muffineer1742013muffineer
muffler15398343muff_ler
office1435693_office_
officers1643803_officers
offices1536243_offices
puffer144610733puff__er
pumicer1335063pu_micer
ruffler13369723ruff_ler
rufflier1434013rufflier
scruffier1743303scruffi_er
scuffer15328883scuff__er
scuffler16286703scuff_ler
scurfier13267053scurfi_er
servicer1335263servicer
shuffler17306803shuff_ler
slicer84117603s__licer
sniffier14356643sniffi_er
snuffer13318853snuff__er
snuffler14317413snuff_ler
snufflier1543303snufflier
spicer104719313s__picer
spiffier16255883spiffi_er
splicer114710523s_plicer
squiffier2442843squiffi_er
stuffer13349793stuff__er
subfile122010503subfile_
subfiles131710723subfiles
subfixes20207493subfixes
sublimer1237613sublimer
subsider1138243subsider
subtiler10208573subtiler
subvicar1544583subvicar
suckier133613973sucki_er
sudsier868783sudsi_er
suffered1536733suffered
sufferers1555103sufferers
suffers133113543suff__ers
sufficient1854223sufficient
sufficing1844883sufficing
suffix1935233suffi__x
suffixal2142853suffixal
suffuse1335443suffuse_
suffused1544023suffused
suffuses1435833suffuses
suiter64121813su__iter
sulfide1138103sulfide_
sulfides1238053sulfides
sulfite10310473sulfite_
sulfites1139903sulfites
sulkier113811963sulki_er
sunnier73412153sunni_er
surface1238653surface_
surfaced1436063surfaced
surfacers1444323surfacers
surfaces1338673surfaces
surfeiter1244713surfeiter
surfer93515883surf__er
surlier72915443surli_er
surmiser1036763surmiser
surviver1434683surviver
tuftier1096603tufti_er
turfier10249793turfi_er

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.406440125.6
2DLD Change Limit146162936.83021400.0
3Display Results93930.0303100.0
 (SQL Overall)178691937.26624592.8
 
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.