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

63 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
frogeyes154374(None) 
frogeye1443811frogeye_
frogeyed1642781frogeyed
fogeys13509262f_ogey_s
apogees1037103apoge_es
bigeyes1335653_bigeyes
bogeyed1435673_bogeyed
bogeys124510913_bogey_s
boogeyed1543723boogeyed
boogeys13476873boogey_s
brogues10719823brog_ues
bugeyes1335513_bugeyes
dogeys115510663_dogey_s
dragees9359483drage_es
drogues9398393drog_ues
fisheyes1744093fisheyes
fogey125617873f_ogey__
fogeyish1843843f_ogeyish
fogeyism1743583f_ogeyism
fogies104118063f_og_ies
foleys123810463f_oley_s
foregoes1239523foregoes
forgeries13310003forgeries
forgers115218183forge_rs
forges105024263forg__es
forgets113813793forge_ts
forgives1535753forgives
forgoes11311353forg_oes
frees86131393fr__e_es
freezes193310353fr_eezes
freres94716173fr__eres
friezes19418913fr_iezes
frigates12310933frigates
friges104116483frig__es
frisees104411693frise_es
froes86126693fro___es
frogged13408493frog_ged
froggier1354643froggier
froggiest1434913froggiest
froggy1434493froggy__
froglet11310063frog_let
froglets1235263froglets
frogmen1335893frog_men
frogs96220773frog___s
fromages1437073fromages
frontes104214163fro_ntes
frounces1336183frounces
mooneyes1396113mooneyes
ogees65119143__oge_es
orogenies10410533orogenies
oxeyes1635893__oxeyes
pogeys124110353_pogey_s
progenies12314123progenies
propenes122816513propenes
proteges1149923proteges
ragees74618663_rage_es
redeyes112910973_redeyes
rogered939553_rogered
rogers74517913_roge_rs
rogues74617673_rog_ues
stogeys11486123stogey_s
urodeles945563urodeles
yogees10510633_yoge_es

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 Filter1786911461620.423422437.4
2DLD Change Limit146162636.92021121.7
3Display Results63630.0163937.5
 (SQL Overall)178691637.35924282.0
 
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.