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 “frizes” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

124 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
frizes18401546(None) 
fries85535601fri_es
friezes19418911friezes
friges104116481friges
frises94124271frises
frites94922481frites
fritzes19329451fritzes
frized193510681frized
frizer184011281frizer
frizers19329551frizers
frizzes18338181frizzes
prizes173819811prizes
arises65233802arises
baizes174315052baizes
bizes165923662_bizes
braizes183112452braizes
brazes175522192brazes
bribes105918532bribes
brides94423512brides
bries74942152bri_es
brines85028852brines
brises84927612brises
crazes174720132crazes
cries75438402cri_es
crimes105521582crimes
cripes105120872cripes
crises84529432crises
crozes174417662crozes
dries64733672dri_es
drives105117112drives
fazes175527212f_azes
feazes184514172feazes
feezes184412612feezes
fezes175220022f_ezes
fezzes174910402fezzes
fices106031162f_ices
fifes114822392f_ifes
files85441272f_iles
fines86644262f_ines
fires85740752f_ires
fives116027362f_ives
fixes154723592f_ixes
fizzes174512552fizzes
flies85630712fli_es
flites95122442flites
fraises104215692fraises
frames115119862frames
frees86131392fr_ees
freezes193310352freezes
freres94716172freres
friars93812092friars
fridges12369482fridges
fried95322912fri_ed
frier85225842fri_er
friers94718932friers
frieze18378142frieze
frigs96019272fri_gs
frills94414222frills
fringes113514102fringes
frise85322452frise_
frisee94217992frisee
frisees104411692frisees
frisks13479262frisks
friths124313582friths
frits86129102fri_ts
fritts94613192fritts
friz166324342friz__
frizz165512622friz_z
frizzed19375972frizzed
frizzer18446892frizzer
frizzers19335102frizzers
frizzies19315932frizzies
frizzles19297282frizzles
frizzy20555832frizzy
froes86126692fr_oes
froze174515652froze_
frozen18408442frozen
furies95126372furi_es
furzes186613692furzes
futzes184313112futzes
fuzes175120222f_uzes
fuzzes175412252fuzzes
grazes164519642grazes
grides84422362grides
grimes94619032grimes
gripes94619872gripes
irides74519122irides
irises64221172irises
krises105016082krises
maizes175115732maizes
phizes20389132phizes
prezes173614692prezes
prices104524542prices
prides94324182prides
pries74339532pri_es
primes104225262primes
prises84133172prises
prize164718942prize_
prized184415392prized
prizer174714882prizer
prizers183911842prizers
razes145032702_razes
ribes75530172_ribes
rices75536152_rices
rides66140812_rides
riles55343642_riles
rimes75634542_rimes
ripes75435772_ripes
rises55244042_rises
rites54442552_rites
ritzes154812942_ritzes
rives85336002_rives
seizes154317532seizes
sizes146727762_sizes
tribes85119022tribes
trices84826332trices
tries55742812tri_es
trikes105419492trikes
trines64132562trines
tripes85324872tripes
urines64724122urines
wizes174723342_wizes
wries85827742wri_es
writes94420332writes

Search took 3 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 Filter178691825510.360496363.9
2DLD Change Limit825511242.15338342.3
3Display Results1241240.0462695.7
 (SQL Overall)1786911242.55969828.4
 
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.