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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

81 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
gripy11511525(None) 
grapy115416431grapy
grimy114312601grimy
grip76127021grip_
gripe84622961gripe
gripey124111201gripey
grippy14447761grippy
grips85520131grips
gript85126171gript
briny104719662briny
crepy124812702crepy
crimpy15489392crimpy
cripe95521142cripe
crispy13478562crispy
drily95816522drily
drip76223952drip_
drippy14445652drippy
drips85417232drips
dript86923872dript
gaily95020972gaily
gappy136212032gappy
gapy106320912g_apy
gimpy135212232gimpy
gip67645362g_ip_
gips75632922g_ips
gipsy11579542g_ipsy
girly94415292girly
goopy115816622goopy
gorily10612502gorily
grainy103914212grainy
grape84824662grape
grapey126012302grapey
graph115315612graph
gravy125512112gravy
gray85329892gr_ay
grey85624042gr_ey
grid65829612gri_d
gride75223582gride
grids75321392grids
grief95319782grief
griff124416462griff
grift95924462grift
grig65424772gri_g
grigs75318192grigs
grill64617892grill
grim76929422gri_m
grime85021322grime
grimly12459932grimly
grin55733722gri_n
grind75917562grind
grins65427222grins
griot65328412griot
griped104114712griped
griper94114612griper
gripes94619872gripes
grippe115310322grippe
grisly104310582grisly
grist65529872grist
grit55247242gri_t
grith95520372grith
grits65529582grits
gritty10338402gritty
grody103412062grody
grope84821612grope
grumpy14498152grumpy
gulpy114612762gulpy
guppy135211272guppy
pipy115421512_pipy
pricy124814562pricy
privy13439832privy
rimy96621282_rimy
rip56851302_rip_
ripe66038922_ripe
rips66237432_rips
ropy96323412_ropy
stripy115812742stripy
trip66830392trip_
tripe75425382tripe
triply114211022triply
trippy13457802trippy
trips74923362trips

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 Filter178691538000.313570897.8
2DLD Change Limit53800811.70331591.3
3Display Results81810.0302700.0
 (SQL Overall)178691812.04687336.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.