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 “frizzz” 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
frizz165512621fri_zz
frizzy20555831frizzy
fizz157519822f_i_zz
fizzy199015082f_izzy
frieze18378142frieze
fritz176020772fri_tz
friz166324342fri__z
frized193510682frized
frizer184011282frizer
frizes184015462frizes
frizzed19375972frizzed
frizzer18446892frizzer
frizzes18338182frizzes
frizzle18367042frizzle
frizzly21455792frizzly
dizzy177410853_dizzy
drizzle16285913drizzle
drizzly19364553drizzly
fezzy199811453f_ezzy
fiz156238763f_i__z
fizzed18369443f_izzed
fizzer17369383f_izzer
fizzes174512553f_izzes
fizzle17369713f_izzle
frazil1847223frazil
frazzle18305223frazzle
freeze18349513freeze
frenzy2135883frenzy
friar85414273fri_ar
friars93812093friars
friary124010093friary
fridge11379253fridge
fried95322913fri_ed
friend10388933friend
frier85225843fri_er
friers94718933friers
fries85535603fri_es
friezes19418913friezes
frig85424503fri__g
friges104116483friges
fright133715243fright
frigid1136923frigid
frigs96019273fri_gs
frijol1634123frijol
frill84917563fri_ll
frills94414223frills
frilly124111443frilly
fringe104013953fringe
fringy13309263fringy
frise85322453fri_se
frisee94217993frisee
frises94124273frises
frisk125312373fri_sk
frisks13479263frisks
frisky16406673frisky
frit77044473fri__t
frites94922483frites
frith115922033fri_th
friths124313583friths
frits86129103fri_ts
fritt86129413fri_tt
fritts94613193fritts
fritzes19329453fritzes
frivol1235113frivol
frizers19329553frizers
frizing203310873frizing
frizzers19335103frizzers
frizzier19284813frizzier
frizzies19315933frizzies
frizzily2253143frizzily
frizzing2064803frizzing
frizzled20325703frizzled
frizzler19345843frizzler
frizzles19297283frizzles
frouzy21395283frouzy
frowzy24485793frowzy
froze174515653fr_oze
frozen18408443frozen
fuzz158420573f__uzz
fuzzy1929814513f_uzzy
grizzle16306113grizzle
grizzly19354473grizzly
pizazz1554223_pizazz
pizza1538183_pizza
pizzaz1565443_pizzaz
prize164718943pri_ze
prized184415393prized
prizer174714883prizer
prizes173819813prizes
razz125219423_r_azz
ritz135129983_ri_tz
ritzy175611163_ritzy
tizzy16548893_tizzy
whizz194210323whi_zz
whizzy23274073whizzy
zzz1017911913___zzz

Search took 6 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 Filter1786911127160.406440125.6
2DLD Change Limit112716965.07622205.7
3Display Results96960.0332909.1
 (SQL Overall)178691965.51532400.9
 
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.