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

100 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
frontiers125499(None) 
frontier1147311frontier_
fronter103611582front_er_
frontes104214162front_e_s
frontless1235402frontless
frontlets1244232frontlets
frostier1148162frostier_
frothers14279812fro_thers
rentiers83311762_rentiers
bronzers19296983bron_zers
bronzier1935633bronzier_
brothers133410833bro_thers
coonties10513803coontie_s
cottiers10399153_cottiers
crofters13358903croft_ers
cronies9622503cron_ie_s
crosiers103312063cro_siers
croupiers1334653croupiers
croziers19287003cro_ziers
droners84114383dron__ers
fainters11349693faint_ers
fanciers13358083f_anciers
flintier1136393flintier_
floaters112711513float_ers
floatier1136983floatier_
flouters11419273flout_ers
flytiers14254483f_lytiers
fondlers12338023f_ondlers
fontinas1136853f_ontinas
footers104618333f_oot_ers
footier104115113f_ootier_
footies103721543f_ootie_s
footlers113910793f_ootlers
forties104323863f_ortie_s
fosters104220103f_ost_ers
frankers15348353fran_kers
fraters103517213fr_at_ers
frenzies2037713frenzie_s
fretters113410303fr_etters
frettier1156593frettier_
friers94718933fr___iers
fringier1236553fringier_
fritters113810783fr_itters
froggier1354643froggier_
fromenties1546673fromentie_s
frondeurs1342573frondeurs
frontages13116183frontages
frontals1146273front_als
fronted114011273front_e_d
frontenis1243423frontenis
frontiersman176503frontiersman
frontiersmen177593frontiersmen
fronting12310443fronti_ng
frontlet1147653frontle_t
frontlines1345193frontlines
frontlists1344523frontlists
frontmen1344423frontme_n
frontons1136503front_ons
fronts94415793front___s
frontward1642573frontward
frontwards1742343frontwards
frosteds12305653frost_eds
frostiest1239213frostiest
frostiness1336563frostiness
frostings1335733frostings
frostless1235743frostless
frother133110153fro_ther_
frothier1435953frothier_
frotteurs1242223frotteurs
frouzier2043703frouzier_
frowners14377933fro_wners
frowsier1444893frowsier_
frowstier1553143frowstier_
frowzier2343313frowzier_
fruiters11328183fruit_ers
fruitier1136593fruitier_
granters93614143grant_ers
grottier9316673grottier_
grouters95910083grout_ers
groutier9297173groutier_
grunters9359033grunt_ers
ironers74813553iron__ers
ironies7517423iron_ie_s
printers103214903print_ers
profiters14228313profiters
prosties101421193prostie_s
ranters73323643_rant_ers
renters74224813_rent_ers
rentier73618223_rentier_
rontgens944683_rontgens
rooters74522933_root_ers
rootier74915393_rootier_
rosters73727543_rost_ers
rotifers1136043_ro_tifers
rotters74421393_ro_tters
routers74822873_rout_ers
runtier73512853_runtier_
trotters83310243tro_tters
troutier8277153troutier_
wrongers12327773wron_gers

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 Filter1786911486410.1561145455.1
2DLD Change Limit1486411007.64019455.6
3Display Results1001000.0502000.0
 (SQL Overall)1786911007.84622774.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.