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

62 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
upfront124697(None) 
affront1357962affront
front85029222__front
refront10313262refront
uproot8314122up_root
affronts1444163affronts
apron7318833ap_ron_
aprons8316993ap_rons
bowfront1644723bowfront
confront13411603confront
defrost1139553defrost
font77143753__f_ont
frond95316343__frond
frons86124043__frons
fronts94415793__fronts
frost84727833__frost
operant9317223operant
operon8811773operon_
operons91411743operons
parent83230423_parent
print74837463_p_rint
prone75332623_p_rone
prong85218113_p_rong
pronto8313993_p_ronto
prost75434103_p_rost
pyrone112714473_pyrone
refronts1137773refronts
seafront1148023seafront
spirant9814293spirant
sprent84522383sp_rent
sprint84526793sp_rint
sprout8419403sp_rout
unfond10149113unf_ond
unfrock1674633unfrock
unfroze1945413unfroze
unrent63219783u_nrent
unroot6315553u_nroot
upborne11255133upborne
updraft1346033updraft
upfling1337093upfling
upflow1433523upflo_w
upflows1543513upflows
upflung1342213upflung
upfold12124953upf_old
upgrow1234273upgro_w
upgrown1343853upgrown
upgrows1334323upgrows
upgrowth1741953upgrowth
uphroe1136083uphro_e
uphroes1236303uphroes
upmost1068193up_most
upon65817583up__on_
upprop944093uppro_p
upprops1044223upprops
uproar8106933up_roar
uproots937143up_roots
uprose82311483up_rose
upsent83314063up_sent
upshoot1256693upshoot
upshot1138453upsho_t
uptorn8268093uptorn_
uptrend1044293uptrend

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 Filter1786911340270.453394461.4
2DLD Change Limit134027626.26621389.6
3Display Results62620.0163875.0
 (SQL Overall)178691626.73526531.7
 
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.