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

54 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
feldshers164309(None) 
feldschers1941761feldschers
feldsher1543241feldsher_
feldscher1842022feldscher_
feldspars1551852feldspars
flashers143912652f_lashers
fleshers14339442f_leshers
flushers14279732f_lushers
welshers14246812wel_shers
belchers153510023bel_chers
blushers133911293_blushers
clashers134213993_clashers
delusters1035983delusters
elders74817303_eld__ers
feasters11511563fe_asters
feathers143513243fe_athers
feeders113712863feed__ers
feldspar1441993feldspar_
fellers104117543fel__lers
felspars1343163fel_spars
fenders113717263fend__ers
festers104121393fe__sters
fetchers16328863fe_tchers
fetishes1437153fetishe_s
fielders12156773field__ers
filchers16286863fil_chers
filisters1237003filisters
finishers1545353finishers
fishers134714723f__ishers
flasher133914063f_lasher_
flashes133916103f_lashe_s
flensers1135463flens_ers
flesher133610923f_lesher_
fleshes133913273f_leshe_s
fletchers17335533fletchers
flossers11307863f_lossers
flusher133012273f_lusher_
flushes134114143f_lushe_s
flusters113811503f_lusters
folders113514393fold__ers
gelders93812573geld__ers
lashers104121833__lashers
melders103213913meld__ers
oldsters996733_oldsters
plashers133813453_plashers
polishers1477603polishers
relishes11311953relishe_s
slashers113313613_slashers
splashers1445283splashers
telphers1335473tel_phers
welchers16338053wel_chers
welders113313413weld__ers
welsher13377443wel_sher_
welshes13379093wel_she_s

Search took 9 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 Limit148641548.06318434.9
3Display Results54540.0301800.0
 (SQL Overall)178691548.24921662.1
 
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.